﻿using System.Data;
using System.Data.SqlClient;

namespace JiaBao.Services.SalerService
{
    /// <summary>
    /// 委托方服务
    /// </summary>
    public interface ISalerService
    {
        /// <summary>
        /// 全部
        /// </summary>
        /// <param name="Id"></param>
        /// <returns></returns>
        DataTable GetByAucId(int Id);

        /// <summary>
        /// 仅未整理
        /// </summary>
        /// <param name="Id"></param>
        /// <returns></returns>
        DataTable GetByAucIdAndOnlyNo(int Id);

        /// <summary>
        /// 所有未整理
        /// </summary>
        /// <returns></returns>
        DataTable GetAllOnlyNo();

        /// <summary>
        /// 自定义Update语句
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="parameter"></param>
        /// <returns></returns>
        int ExecuteNonQuery(string sql, params SqlParameter[] parameter);

        /// <summary>
        /// 整理客户资料
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        int UpdateByAucId(int id);

        /// <summary>
        /// 根据Guid获取卖家
        /// </summary>
        /// <param name="guid"></param>
        /// <returns></returns>
        DataTable GetByGUID(string guid);
    }
}
